// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_SALES_PROD_PLAN_APPLICATION_ITEM
// * CreateDate    : 2012-1-2 10:44:36
// * Creater       : CodeSmith
// * LastChangeDate: 2012-1-2 10:44:36
// * LastChanger   : 2012-1-2 10:44:36
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
    [Serializable]
    public partial class SalesProdPlanApplicationItemTable : TableInfo
    {
        public const string C_TableName = "SALES_PROD_PLAN_APPLICATION_ITEM";

        public const string C_APPLICATION_ITEM_ID = "APPLICATION_ITEM_ID";
        public const string C_APPLICATION_ID = "APPLICATION_ID";
        public const string C_CONTACT_ID = "CONTACT_ID";
        public const string C_PRODUCT_ID = "PRODUCT_ID";
        public const string C_REQUIRED_DELIVERY_DATE = "REQUIRED_DELIVERY_DATE";
        public const string C_LOCATION_CODE = "LOCATION_CODE";
        public const string C_QTY = "QTY";
        public const string C_PRICE = "PRICE";
        public const string C_PRICE_TYPE = "PRICE_TYPE";
        public const string C_PRODUCT_TYPE = "PRODUCT_TYPE";
        public const string C_BLUEPRINT_START_DATE = "BLUEPRINT_START_DATE";
        public const string C_BLUEPRINT_END_DATE = "BLUEPRINT_END_DATE";
        public const string C_PACKAGE_TYPE = "PACKAGE_TYPE";
        public const string C_CHECKING_TYPE = "CHECKING_TYPE";
        public const string C_PRINT_BRAND = "PRINT_BRAND";
        public const string C_IS_FINISHED = "IS_FINISHED";
        public const string C_DELIVERY_APPLICATION = "DELIVERY_APPLICATION";
        public const string C_DELIVERY_QTY = "DELIVERY_QTY";
        public const string C_STATUS = "STATUS";
        public const string C_REMARK = "REMARK";
        public const string C_PRODUCT_SPEC_IN = "PRODUCT_SPEC_IN";
        public const string C_PRODUCT_SPEC_OUT = "PRODUCT_SPEC_OUT";
        public const string C_MATERIAL = "MATERIAL";
        public const string C_DIAMETER_OUT = "DIAMETER_OUT";
        public const string C_DIAMETER_IN = "DIAMETER_IN";
        public const string C_LENGTH = "LENGTH";
        public const string C_UNIT = "UNIT";
        public const string C_ORDER_ITEM_ID = "ORDER_ITEM_ID";
        public const string C_REGISTER_ITEM_ID = "REGISTER_ITEM_ID";

        public SalesProdPlanApplicationItemTable()
        {
            _tableName = "SALES_PROD_PLAN_APPLICATION_ITEM";
        }

        protected static SalesProdPlanApplicationItemTable _current;
        public static SalesProdPlanApplicationItemTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }

        private static void Initial()
        {
            _current = new SalesProdPlanApplicationItemTable();

            _current.Add(C_APPLICATION_ITEM_ID, new ColumnInfo(C_APPLICATION_ITEM_ID, "ApplicationItemId", true, typeof(string)));
            _current.Add(C_APPLICATION_ID, new ColumnInfo(C_APPLICATION_ID, "ApplicationId", false, typeof(string)));
            _current.Add(C_CONTACT_ID, new ColumnInfo(C_CONTACT_ID, "ContactId", false, typeof(string)));
            _current.Add(C_PRODUCT_ID, new ColumnInfo(C_PRODUCT_ID, "ProductId", false, typeof(string)));
            _current.Add(C_REQUIRED_DELIVERY_DATE, new ColumnInfo(C_REQUIRED_DELIVERY_DATE, "RequiredDeliveryDate", false, typeof(DateTime)));
            _current.Add(C_LOCATION_CODE, new ColumnInfo(C_LOCATION_CODE, "LocationCode", false, typeof(string)));
            _current.Add(C_QTY, new ColumnInfo(C_QTY, "Qty", false, typeof(decimal)));
            _current.Add(C_PRICE, new ColumnInfo(C_PRICE, "Price", false, typeof(decimal)));
            _current.Add(C_PRICE_TYPE, new ColumnInfo(C_PRICE_TYPE, "PriceType", false, typeof(string)));
            _current.Add(C_PRODUCT_TYPE, new ColumnInfo(C_PRODUCT_TYPE, "ProductType", false, typeof(string)));
            _current.Add(C_BLUEPRINT_START_DATE, new ColumnInfo(C_BLUEPRINT_START_DATE, "BlueprintStartDate", false, typeof(DateTime)));
            _current.Add(C_BLUEPRINT_END_DATE, new ColumnInfo(C_BLUEPRINT_END_DATE, "BlueprintEndDate", false, typeof(DateTime)));
            _current.Add(C_PACKAGE_TYPE, new ColumnInfo(C_PACKAGE_TYPE, "PackageType", false, typeof(string)));
            _current.Add(C_CHECKING_TYPE, new ColumnInfo(C_CHECKING_TYPE, "CheckingType", false, typeof(string)));
            _current.Add(C_PRINT_BRAND, new ColumnInfo(C_PRINT_BRAND, "PrintBrand", false, typeof(int)));
            _current.Add(C_IS_FINISHED, new ColumnInfo(C_IS_FINISHED, "IsFinished", false, typeof(int)));
            _current.Add(C_DELIVERY_APPLICATION, new ColumnInfo(C_DELIVERY_APPLICATION, "DeliveryApplication", false, typeof(string)));
            _current.Add(C_DELIVERY_QTY, new ColumnInfo(C_DELIVERY_QTY, "DeliveryQty", false, typeof(decimal)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS, "Status", false, typeof(string)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK, "Remark", false, typeof(string)));
            _current.Add(C_PRODUCT_SPEC_IN, new ColumnInfo(C_PRODUCT_SPEC_IN, "ProductSpecIn", false, typeof(string)));
            _current.Add(C_PRODUCT_SPEC_OUT, new ColumnInfo(C_PRODUCT_SPEC_OUT, "ProductSpecOut", false, typeof(string)));
            _current.Add(C_MATERIAL, new ColumnInfo(C_MATERIAL, "Material", false, typeof(string)));
            _current.Add(C_DIAMETER_OUT, new ColumnInfo(C_DIAMETER_OUT, "DiameterOut", false, typeof(decimal)));
            _current.Add(C_DIAMETER_IN, new ColumnInfo(C_DIAMETER_IN, "DiameterIn", false, typeof(decimal)));
            _current.Add(C_LENGTH, new ColumnInfo(C_LENGTH, "Length", false, typeof(decimal)));
            _current.Add(C_UNIT, new ColumnInfo(C_UNIT, "Unit", false, typeof(string)));
            _current.Add(C_ORDER_ITEM_ID, new ColumnInfo(C_ORDER_ITEM_ID, "OrderItemId", false, typeof(string)));
            _current.Add(C_REGISTER_ITEM_ID, new ColumnInfo(C_REGISTER_ITEM_ID, "RegisterItemId", false, typeof(string)));

        }

        public ColumnInfo APPLICATION_ITEM_ID
        {
            get { return this[C_APPLICATION_ITEM_ID]; }
        }

        public ColumnInfo APPLICATION_ID
        {
            get { return this[C_APPLICATION_ID]; }
        }

        public ColumnInfo CONTACT_ID
        {
            get { return this[C_CONTACT_ID]; }
        }

        public ColumnInfo PRODUCT_ID
        {
            get { return this[C_PRODUCT_ID]; }
        }

        public ColumnInfo REQUIRED_DELIVERY_DATE
        {
            get { return this[C_REQUIRED_DELIVERY_DATE]; }
        }

        public ColumnInfo LOCATION_CODE
        {
            get { return this[C_LOCATION_CODE]; }
        }

        public ColumnInfo QTY
        {
            get { return this[C_QTY]; }
        }

        public ColumnInfo PRICE
        {
            get { return this[C_PRICE]; }
        }

        public ColumnInfo PRICE_TYPE
        {
            get { return this[C_PRICE_TYPE]; }
        }

        public ColumnInfo PRODUCT_TYPE
        {
            get { return this[C_PRODUCT_TYPE]; }
        }

        public ColumnInfo BLUEPRINT_START_DATE
        {
            get { return this[C_BLUEPRINT_START_DATE]; }
        }

        public ColumnInfo BLUEPRINT_END_DATE
        {
            get { return this[C_BLUEPRINT_END_DATE]; }
        }

        public ColumnInfo PACKAGE_TYPE
        {
            get { return this[C_PACKAGE_TYPE]; }
        }

        public ColumnInfo CHECKING_TYPE
        {
            get { return this[C_CHECKING_TYPE]; }
        }

        public ColumnInfo PRINT_BRAND
        {
            get { return this[C_PRINT_BRAND]; }
        }

        public ColumnInfo IS_FINISHED
        {
            get { return this[C_IS_FINISHED]; }
        }

        public ColumnInfo DELIVERY_APPLICATION
        {
            get { return this[C_DELIVERY_APPLICATION]; }
        }

        public ColumnInfo DELIVERY_QTY
        {
            get { return this[C_DELIVERY_QTY]; }
        }

        public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }

        public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }

        public ColumnInfo PRODUCT_SPEC_IN
        {
            get { return this[C_PRODUCT_SPEC_IN]; }
        }

        public ColumnInfo PRODUCT_SPEC_OUT
        {
            get { return this[C_PRODUCT_SPEC_OUT]; }
        }

        public ColumnInfo MATERIAL
        {
            get { return this[C_MATERIAL]; }
        }

        public ColumnInfo DIAMETER_OUT
        {
            get { return this[C_DIAMETER_OUT]; }
        }

        public ColumnInfo DIAMETER_IN
        {
            get { return this[C_DIAMETER_IN]; }
        }

        public ColumnInfo LENGTH
        {
            get { return this[C_LENGTH]; }
        }

        public ColumnInfo UNIT
        {
            get { return this[C_UNIT]; }
        }

        public ColumnInfo ORDER_ITEM_ID
        {
            get { return this[C_ORDER_ITEM_ID]; }
        }

        public ColumnInfo REGISTER_ITEM_ID
        {
            get { return this[C_REGISTER_ITEM_ID]; }
        }


    }
}

